﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace pttk_htt_hr.Constant
{
    class StoreProcedureConstant
    {
        /*SELECT*/
        // Gia
        public static string SP_SELECT_TatCaLoaiGia_PhongCo = "sp_test";

        public static string sp_M_Phong_M_GiaPhongTheoNguoi = "sp_M_Phong_M_GiaPhongTheoNguoi";
        public static string sp_M_Phong_M_GiaPhongTheoGio = "sp_M_Phong_M_GiaPhongTheoGio";
        public static string sp_M_Phong_M_GiaPhongTheoDemNgayTuanThang = "sp_M_Phong_M_GiaPhongTheoDemNgayTuanThang";
         public static string sp_LayThongTinPhong = "sp_LayThongTinPhong";
        

        //THUC DON
        public static string SP_SELECT_THUC_DON= "sp_select_THUC_DON";
        public static string SP_SELECT_THUC_DON_ById = "sp_select_THUC_DON_ById";
        public static string SP_SELECT_THUC_DON_ByConds = "sp_select_THUC_DON_ByConds";

        //CHI_TIET_PHIEU_LAP_TD_TUAN_TOI
        public static string SP_SELECT_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI = "sp_select_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI_byMaPLTDTT";

        //PHIEU_LAP_TD_TUAN_TOI
        public static string SP_SELECT_PHIEU_LAP_TD_TUAN_TOI_ById = "sp_select_PHIEU_LAP_TD_TUAN_TOI_ById";
        public static string SP_SELECT_PHIEU_LAP_TD_TUAN_TOI_ByConds = "sp_select_PHIEU_LAP_TD_TUAN_TOI_ByConds";
        public static string SP_SELECT_PHIEU_LAP_TD_TUAN_TOI = "sp_select_PHIEU_LAP_TD_TUAN_TOI";

        /*
         * INSERT
         */

        public static string SP_INSERT_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI = "sp_insert_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI";
        public static string SP_INSERT_PHIEU_LAP_TD_TUAN_TOI = "sp_insert_PHIEU_LAP_TD_TUAN_TOI";


        /*
         * UPDATE
         */
        public static string SP_UPDATE_PHIEU_LAP_TD_TUAN_TOI = "sp_update_PHIEU_LAP_TD_TUAN_TOI";
        public static string SP_UPDATE_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI = "sp_update_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI";

        /*
         * DELETE
         */
        
        public static string SP_DELETE_PHIEU_LAP_TD_TUAN_TOI = "sp_delete_PHIEU_LAP_TD_TUAN_TOI";
        public static string SP_DELETE_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI = "sp_delete_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI";
        public static string SP_DELETE_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI_BY_MaPLTDTT_MaTD = "sp_delete_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI_By_MaPLTDTT_MaTD";
        

        /*
        * COUNT
        */
        public static string SP_COUNT_THUCDON_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI = "sp_count_THUC_DON_CHI_TIET_PHIEU_LAP_TD_TUAN_TOI_ByMaPLTDTT_MaTD";

        /*
         * OTHERS
         */
        public static string SP_GET_CURRENT_ID = "sp_GetCurrentID";
        public static string SP_GET_NEXT_ID = "sp_GetNextID";
    }
}
